package nciae.db.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import nciae.db.pojo.entity.Student;
import nciae.db.pojo.vo.StudentCountVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;


@Mapper
public interface StudentMapper extends BaseMapper<Student> {

    @Select("SELECT project_id, COUNT(*) AS count FROM student GROUP BY project_id")
    List<StudentCountVO> selectProjectStudentCount();



}
